2016-10-10 - 28185 - Enhancement - Scorecard Season and collection update #CrystalReportsSupport
SPECIFICATIONS
28185 - Scorecard Season and collection update
Purpose
Need to remove hot market season and collection from the projected open orders in SA110 and SA115 as per the executive decision.
Admin Info
Purpose
|
Need to remove hot market season and collection from the projected open orders in sa110 and sa115 as per the executive decision
|
Requested By
|
Ashley Moreira
|
Spec Created By
|
Venkateswara Reddy
|
Spec Created Date
|
10/10/2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
SA110,SA115 Reports
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
04
|
2
|
Documentation
|
02
|
3
|
Development/ Config
|
20
|
4
|
Unit test
|
20
|
6
|
Other activity
|
04
|
|
TOTAL
|
50
|
References
Prior Tickets
None
Documents
The following collections have to be excluded from Sales Org 1000:
Hot Season & Collection.txt
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to remove hot market season and collection from the projected open orders in SA110 and SA115 as per the executive decision.
In Scope:
SA110 and SA115 Reports for North America Region.
Out of Scope:
Other Regional Scorecards.
Solution Summary
BW Changes:
1. Need to add Season & Collection to to Scorecard Multiprovider.
2. Need to create new version of BEx Queries by adding Season & Collection.
Crystal Changes:
1. Need to update BEx Queries with Crystal reports.
2. Need to develop new logic to exclude HOT marke Season & Collection for particular Sales Org 1000 on Open Order Measures.
3. Need to validate both reports and with BEx Queries.
4. Need to do crystal report formatting according to NEC Standards.
Solution Details
BW Changes:
1. Need to add Season & Collection to to Scorecard Multiprovider.
2. Need to create new version Of BEx Queries by adding Season & Collection.
Crystal Changes:
1. Need to update BEx Queries with Crystal reports.
2. Need to develop new logic to exclude HOT market Season & Collection for particular Sales Org 1000 on Open Order Measures.
3. Need to validate both reports and with BEx Queries.
4. Need to do crystal report formatting according to NEC Standards.
Issues
None